Task

EntityType | Independent
Logical Entity Name | Task
Default Table Name | CmEvent
Logical Only | NO
Owner | dbo
Definition |
Note |

Task Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TaskStartDate |  | DATETIME | YES |
TaskEndDate |  | DATETIME | YES |
RemindDate |  | DATETIME | YES |
TaskDueDate |  | DATETIME | YES |
Note |  | TEXT | NO |
Subject |  | VARCHAR(255) | YES |
Priority |  | CHAR(10) | NO |
TaskTemplateId |  | INTEGER | YES |
TaskTypeId |  | INTEGER | YES |
TaskStatusId |  | INTEGER | YES |
TaskStatusDate |  | DATETIME | YES |
TaskResultId |  | INTEGER | YES |
SourceRecordID |  | INTEGER | NO |
SourceTable |  | CHAR(20) | NO |
ResultText |  | VARCHAR(255) | YES |
CreatedByStaffId |  | INTEGER | NO |
CompletedByStaffId |  | INTEGER | NO |
TemplateTextFile |  | VARCHAR(50) | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
ModFlag |  | CHAR(1) | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
TaskId |  | INTEGER | NO |
EmployerId |  | INTEGER | YES |
StaffId |  | INTEGER | YES |
StudentId |  | INTEGER | YES |
ProspectInquiryId |  | INTEGER | YES |
Attachments |  | VARCHAR(1280) | YES |
PlEmployerJobID |  | INTEGER | YES |
EmployerContactId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
SessionSyCampusID |  | INTEGER | YES |
IsActivityNotViewed |  | BIT | NO |
ReassignedDate |  | DATETIME | YES |
OrganizationId |  | INTEGER | YES |
OrganizationContactId |  | INTEGER | YES |
EmailSubject |  | VARCHAR(255) | YES |
SourceSystem |  | CHAR(1) | NO |
PreviouslyAssignedToStaffId |  | INTEGER | YES |
LockedByUserId |  | INTEGER | YES |
AttachmentId |  | INTEGER | YES |
CrmSuppressFlag |  | BIT | NO |
WorkflowInstanceIdentifier |  | UNIQUEID | YES |
ClassSectionId |  | INTEGER | YES |

Task Keys

Key Name | Key Type | Keys
CmEvent_CmEventID_U_C_IDX | PrimaryKey | TaskId
Fk_CmEventSyOrganizationID_SyOrganizationSyOrganizationID | Inversion Entry | OrganizationId
CmEvent_DueDate_N_N_IDX | Inversion Entry | TaskDueDate
NK_CmEventLockedBy | Inversion Entry | LockedByUserId
NK_CmEventPrevSyStaffID | Inversion Entry | PreviouslyAssignedToStaffId
CmEvent_CmEventStatusID_SyStudentID_CmEventTypeID_CmEventID_U_N_IDX | Alternate Key | TaskId
CmEvent_CmTemplateID_CmEventStatusID_DueDate_SyStudentID_PlEmployerID_N_N_IDX | Inversion Entry | TaskDueDate
CmEvent_SyStudentID_CmEventStatusID_DateLstMod_N_N_IDX | Inversion Entry | LastModifiedDateTime
CmEvent_SyStaffId_CmEventStatusId_DueDate_CmEventId_U_N_IDX | Alternate Key | StaffId, TaskDueDate, TaskId
UK_CmEvent_CmEventTypeID_CmEventStatusID_DueDate_SyStudentID_SourceSystem | Inversion Entry | TaskDueDate, SourceSystem
CmEvent_SyStaffId_CmTemplateID_CmEventStatusId_DueDate_CmEventId_U_N_IDX | Alternate Key | StaffId, TaskDueDate, TaskId
CmEvent_plEmployerId_CmEventStatusID_DueDate_CmEventId_CmEventTypeId_U_N_IDX | Alternate Key | TaskDueDate, TaskId

Task Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Attachment | Non-Identifying | Zero or One to Zero or More |  |  |  | AttachmentId | NO
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
Employer | Non-Identifying | Zero or One to Zero or More |  |  |  | EmployerId | NO
EmployerContact | Non-Identifying | Zero or One to Zero or More |  |  |  | EmployerContactId | NO
EmployerJob | Non-Identifying | Zero or One to Zero or More |  |  |  | PlEmployerJobID | NO
Attachment | Non-Identifying | Zero or One to Zero or More |  |  |  | AttachmentId | NO
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | SessionSyCampusID | NO
SyOrganizationContact | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationContactId | NO
SyOrganization | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | LockedByUserId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | PreviouslyAssignedToStaffId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
ProspectInquiry | Non-Identifying | Zero or One to Zero or More |  |  |  | ProspectInquiryId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
SyOrganization | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationId | NO
SyOrganizationContact | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationContactId | NO
TaskResult | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskResultId | NO
TaskStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskStatusId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTemplateId | NO
TaskType | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTypeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
cmEventExternalMap | Non-Identifying | One To Zero or More |  |  |  |  | NO
CmEventIncident | Non-Identifying | One To Zero or More |  |  |  |  | NO
HSStudentLeaseEvent | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyMailInboxQueue | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskDocumentAttachment | Non-Identifying | One To Zero or More |  |  |  |  | NO

Task Check Constraints

Check Constraint Name | CheckConstraint

Task Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Task | NO |  |  |
Physical (Microsoft SQL Server) dbo.CmEvent | NO |  |  |

Task Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Career Services

Task Data Movement Rules

Name | Type | Rule Text/Value